MODULE 01
Power BI Overview & Power Query
Power BI Desktop, Power Query, Data Model, DAX & Service components, end-to-end workflow flowchart & Power Query data cleaning checklist.
MODULE 02
Sample Dataset & Columns vs Measures
Practice Sales dataset (8 rows), expected totals (Sales ₹2.87L, Cost ₹2.27L, Profit ₹59.8K), data import steps flowchart, and Calculated Column vs Measure vs Table rules.
MODULE 03
DAX Operators & Function Reference
DAX symbols & operators (+, *, ==, &&, ||, &, VAR/RETURN), column vs measure syntax, aggregations (SUM, COUNTROWS, DISTINCTCOUNT), IF/SWITCH & DIVIDE.
MODULE 04
Iterator Functions (SUMX & RANKX)
SUMX row-by-row execution model flowchart, SUM vs SUMX detailed comparison, AVERAGEX, COUNTX, and RANKX with DESC & DENSE ties handling.
MODULE 05
CALCULATE, FILTER & Filter Context
CALCULATE mechanics, FILTER function, filter modifiers (ALL, REMOVEFILTERS, ALLEXCEPT), Sales Share %, Row Context vs Filter Context vs Context Transition & SUMMARIZE virtual tables.
MODULE 06
Date Intelligence & Time Analysis
Calendar Table creation (CALENDAR), 1-to-many relationships, month sorting rule, MTD, YTD, PREVIOUSMONTH, SAMEPERIODLASTYEAR, Sales Growth & Growth %.
MODULE 07
Advanced Measures & Visual Selection Guide
Product %, Top Products Rank, Target Achievement %, Running Total, Dynamic Titles, 18 Chart selection guide, chart mockups, and Dashboard Creation 8-step flowchart.
MODULE 08
Debugging, Practice Assignments & 50+ Q&A
DAX Troubleshooting table, Publishing checklist, 12 Practice Assignments with hints, Quick DAX Glossary, Best Learning Sequence & 50 Master Interview Q&A.